Budget

EntityType | Independent
Logical Entity Name | Budget
Default Table Name | FABudget
Logical Only | NO
Owner | dbo
Definition |
Note |

Budget Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Id |  | INTEGER | NO |
Code |  | CHAR(8) | NO |
Name |  | VARCHAR(40) | NO |
CampusGroupId |  | INTEGER | NO |
RoomBoard |  | MONEY(19, 4) | YES |
Travel |  | MONEY(19, 4) | YES |
OtherDescription1 |  | VARCHAR(40) | YES |
OtherAmount1 |  | MONEY(19, 4) | YES |
OtherDescription2 |  | VARCHAR(40) | YES |
OtherAmount2 |  | MONEY(19, 4) | YES |
OtherDescription3 |  | VARCHAR(40) | YES |
OtherAmount3 |  | MONEY(19, 4) | YES |
OtherDescription4 |  | VARCHAR(40) | YES |
OtherAmount4 |  | MONEY(19, 4) | YES |
IsActive |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
Books |  | MONEY(19, 4) | YES |
IsOtherCharge1Institutional |  | BIT | NO |
IsOtherCharge2Institutional |  | BIT | NO |
IsOtherCharge3Institutional |  | BIT | NO |
IsOtherCharge4Institutional |  | BIT | NO |
Tuition |  | MONEY(19, 4) | YES |
InstitutionChargesCalcMethod |  | CHAR(1) | YES |
OtherAmount5 |  | MONEY(19, 4) | YES |
OtherAmount6 |  | MONEY(19, 4) | YES |
OtherAmount7 |  | MONEY(19, 4) | YES |
OtherAmount8 |  | MONEY(19, 4) | YES |
OtherDescription5 |  | CHAR(40) | YES |
OtherDescription6 |  | CHAR(40) | YES |
OtherDescription7 |  | CHAR(40) | YES |
OtherDescription8 |  | CHAR(40) | YES |
IsOtherCharge5Institutional |  | BIT | NO |
IsOtherCharge6Institutional |  | BIT | NO |
IsOtherCharge7Institutional |  | BIT | NO |
IsOtherCharge8Institutional |  | BIT | NO |
OffCampusRoomBoard |  | MONEY(19, 4) | YES |
OffCampusTravel |  | MONEY(19, 4) | YES |
OffCampusOtherDescription1 |  | VARCHAR(40) | YES |
OffCampusOtherDescription2 |  | VARCHAR(40) | YES |
OffCampusOtherDescription3 |  | VARCHAR(40) | YES |
OffCampusOtherDescription4 |  | VARCHAR(40) | YES |
OffCampusOtherDescription5 |  | VARCHAR(40) | YES |
OffCampusOtherDescription6 |  | VARCHAR(40) | YES |
OffCampusOtherDescription7 |  | VARCHAR(40) | YES |
OffCampusOtherDescription8 |  | VARCHAR(40) | YES |
OffCampusOtherAmount1 |  | MONEY(19, 4) | YES |
OffCampusOtherAmount2 |  | MONEY(19, 4) | YES |
OffCampusOtherAmount3 |  | MONEY(19, 4) | YES |
OffCampusOtherAmount4 |  | MONEY(19, 4) | YES |
OffCampusOtherAmount5 |  | MONEY(19, 4) | YES |
OffCampusOtherAmount6 |  | MONEY(19, 4) | YES |
OffCampusOtherAmount7 |  | MONEY(19, 4) | YES |
OffCampusOtherAmount8 |  | MONEY(19, 4) | YES |
IsOffCampusOtherCharge1Institutional |  | BIT | NO |
IsOffCampusOtherCharge2Institutional |  | BIT | NO |
IsOffCampusOtherCharge3Institutional |  | BIT | NO |
IsOffCampusOtherCharge4Institutional |  | BIT | NO |
IsOffCampusOtherCharge5Institutional |  | BIT | NO |
IsOffCampusOtherCharge6Institutional |  | BIT | NO |
IsOffCampusOtherCharge7Institutional |  | BIT | NO |
IsOffCampusOtherCharge8Institutional |  | BIT | NO |
OnCampusRoomBoard |  | MONEY(19, 4) | YES |
OnCampusTravel |  | MONEY(19, 4) | YES |
OnCampusOtherDescription1 |  | VARCHAR(40) | YES |
OnCampusOtherDescription2 |  | VARCHAR(40) | YES |
OnCampusOtherDescription3 |  | VARCHAR(40) | YES |
OnCampusOtherDescription4 |  | VARCHAR(40) | YES |
OnCampusOtherDescription5 |  | VARCHAR(40) | YES |
OnCampusOtherDescription6 |  | VARCHAR(40) | YES |
OnCampusOtherDescription7 |  | VARCHAR(40) | YES |
OnCampusOtherDescription8 |  | VARCHAR(40) | YES |
OnCampusOtherAmount1 |  | MONEY(19, 4) | YES |
OnCampusOtherAmount2 |  | MONEY(19, 4) | YES |
OnCampusOtherAmount3 |  | MONEY(19, 4) | YES |
OnCampusOtherAmount4 |  | MONEY(19, 4) | YES |
OnCampusOtherAmount5 |  | MONEY(19, 4) | YES |
OnCampusOtherAmount6 |  | MONEY(19, 4) | YES |
OnCampusOtherAmount7 |  | MONEY(19, 4) | YES |
OnCampusOtherAmount8 |  | MONEY(19, 4) | YES |
IsOnCampusOtherCharge1Institutional |  | BIT | NO |
IsOnCampusOtherCharge2Institutional |  | BIT | NO |
IsOnCampusOtherCharge3Institutional |  | BIT | NO |
IsOnCampusOtherCharge4Institutional |  | BIT | NO |
IsOnCampusOtherCharge5Institutional |  | BIT | NO |
IsOnCampusOtherCharge6Institutional |  | BIT | NO |
IsOnCampusOtherCharge7Institutional |  | BIT | NO |
IsOnCampusOtherCharge8Institutional |  | BIT | NO |
IsMonthlyBudget |  | BIT | NO |

Budget Keys

Key Name | Key Type | Keys
FABudget_FABudgetID_U_C_IDX | PrimaryKey | Id

Budget Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
ProgramVersion | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAcademicYear | Non-Identifying | One To Zero or More |  |  |  |  | NO

Budget Check Constraints

Check Constraint Name | CheckConstraint

Budget Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.Budget | NO |  |  |
Physical (Microsoft SQL Server) dbo.FABudget | NO |  |  |

Budget Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records
Physical (Microsoft SQL Server) | Financial Aid

Budget Data Movement Rules

Name | Type | Rule Text/Value